
package com.example.dropoff;

import android.provider.BaseColumns;

public final class DataBases {
	
	public static final class CreateDB implements BaseColumns{
		public static final String NAME = "name";
		public static final String DATE_YY = "date_yy";
		public static final String DATE_MM = "date_mm";
		public static final String DATE_DD = "date_dd";
		public static final String AMOUNT = "amount";
		public static final String UNIT = "unit";
		public static final String MEMO = "memo";
		public static final String _TABLENAME ="itemlist";
		public static final String _CREATE =
			"create table "+_TABLENAME+"("
				+_ID+" integer primary key autoincrement, "
				+NAME+" text not null, "
				+DATE_YY+" text not null, "
				+DATE_MM+" text not null, "
				+DATE_DD+" text not null, "
				+AMOUNT+" text not null, "
				+UNIT+" text not null, "
				+MEMO+" text null);";
	}
}
